﻿INSERT INTO [ReportingCenterContent].[dbo].[TeamSet]
           ([ShortTeamName]
           ,[LongTeamName]
           ,[TeamIntroduction])
     VALUES
           ('BIAR'
           ,'Business Intelligence'
           ,'BIAR team')
INSERT INTO [ReportingCenterContent].[dbo].[PeopleSet]
           ([Alias]
           ,[TeamId])
     VALUES
           ('alias'
           ,1)
INSERT INTO [ReportingCenterContent].[dbo].[TeamSet]
           ([ShortTeamName]
           ,[LongTeamName]
           ,[TeamIntroduction])
     VALUES
           ('GPS'
           ,'Global Partner Support BI'
           ,'GPS sub-team')
INSERT INTO [ReportingCenterContent].[dbo].[PeopleSet]
           ([Alias]
           ,[TeamId])
     VALUES
           ('alias'
           ,2)
INSERT INTO [ReportingCenterContent].[dbo].[TeamSet]
           ([ShortTeamName]
           ,[LongTeamName]
           ,[TeamIntroduction])
     VALUES
           ('CTS'
           ,'Commercial Technology Support BI'
           ,'CTS sub-team')
INSERT INTO [ReportingCenterContent].[dbo].[PeopleSet]
           ([Alias]
           ,[TeamId])
     VALUES
           ('alias'
           ,3)
INSERT INTO [ReportingCenterContent].[dbo].[TeamSet]
           ([ShortTeamName]
           ,[LongTeamName]
           ,[TeamIntroduction])
     VALUES
           ('COS'
           ,'Community & Online Support BI'
           ,'COS sub-team')
INSERT INTO [ReportingCenterContent].[dbo].[PeopleSet]
           ([Alias]
           ,[TeamId])
     VALUES
           ('alias'
           ,4)
INSERT INTO [ReportingCenterContent].[dbo].[TeamSet]
           ([ShortTeamName]
           ,[LongTeamName]
           ,[TeamIntroduction])
     VALUES
           ('CS'
           ,'Global Customer Service BI'
           ,'CS sub-team')
INSERT INTO [ReportingCenterContent].[dbo].[PeopleSet]
           ([Alias]
           ,[TeamId])
     VALUES
           ('alias'
           ,5)
GO

INSERT INTO [ReportingCenterContent].[dbo].[ReportCategorySet]
           ([ReportCategoryName]
           ,[TeamId])
     VALUES
           ('Category1'
           ,1)
INSERT INTO [ReportingCenterContent].[dbo].[ReportSet]
           ([ReportName]
           ,[ReportURL]
           ,[ReportDescription]
           ,[ReportCategoryId]
           )
     VALUES
           ('sample1',
			'#',
			'sample text',
			1			
           )
INSERT INTO [ReportingCenterContent].[dbo].[ReportCategorySet]
           ([ReportCategoryName]
           ,[TeamId])
     VALUES
           ('Category2'
           ,1)           
INSERT INTO [ReportingCenterContent].[dbo].[ReportSet]
           ([ReportName]
           ,[ReportURL]
           ,[ReportDescription]
           ,[ReportCategoryId]
           )
     VALUES
           ('sample1',
			'#',
			'sample text',
			2			
           )
INSERT INTO [ReportingCenterContent].[dbo].[MiscSet]
           ([Title]
           ,[Content]
           ,[TeamId]
           )
     VALUES
           ('misc'
           ,'misc'
           ,1
           )
INSERT INTO [ReportingCenterContent].[dbo].[IssueSet]
           ([Title]
           ,[Content]
           ,[TeamId]
           )
     VALUES
           ('issue'
           ,'issue'
           ,1
           )
INSERT INTO [ReportingCenterContent].[dbo].[NewsSet]
           ([Title]
           ,[Content]
           ,[TeamId]
           )
     VALUES
           ('news'
           ,'news'
           ,1
           )

INSERT INTO [ReportingCenterContent].[dbo].[ReportCategorySet]
           ([ReportCategoryName]
           ,[TeamId])
     VALUES
           ('Category1'
           ,2)
INSERT INTO [ReportingCenterContent].[dbo].[ReportSet]
           ([ReportName]
           ,[ReportURL]
           ,[ReportDescription]
           ,[ReportCategoryId]
           )
     VALUES
           ('sample1',
			'#',
			'sample text',
			3			
           )
INSERT INTO [ReportingCenterContent].[dbo].[ReportCategorySet]
           ([ReportCategoryName]
           ,[TeamId])
     VALUES
           ('Category2'
           ,2)           
INSERT INTO [ReportingCenterContent].[dbo].[ReportSet]
           ([ReportName]
           ,[ReportURL]
           ,[ReportDescription]
           ,[ReportCategoryId]
           )
     VALUES
           ('sample1',
			'#',
			'sample text',
			4			
           )
INSERT INTO [ReportingCenterContent].[dbo].[MiscSet]
           ([Title]
           ,[Content]
           ,[TeamId]
           )
     VALUES
           ('misc'
           ,'misc'
           ,2
           )
INSERT INTO [ReportingCenterContent].[dbo].[IssueSet]
           ([Title]
           ,[Content]
           ,[TeamId]
           )
     VALUES
           ('issue'
           ,'issue'
           ,2
           )
INSERT INTO [ReportingCenterContent].[dbo].[NewsSet]
           ([Title]
           ,[Content]
           ,[TeamId]
           )
     VALUES
           ('news'
           ,'news'
           ,2
           )
INSERT INTO [ReportingCenterContent].[dbo].[ReportCategorySet]
           ([ReportCategoryName]
           ,[TeamId])
     VALUES
           ('Category1'
           ,3)
INSERT INTO [ReportingCenterContent].[dbo].[ReportSet]
           ([ReportName]
           ,[ReportURL]
           ,[ReportDescription]
           ,[ReportCategoryId]
           )
     VALUES
           ('sample1',
			'#',
			'sample text',
			5			
           )
INSERT INTO [ReportingCenterContent].[dbo].[ReportCategorySet]
           ([ReportCategoryName]
           ,[TeamId])
     VALUES
           ('Category2'
           ,3)   
INSERT INTO [ReportingCenterContent].[dbo].[ReportSet]
           ([ReportName]
           ,[ReportURL]
           ,[ReportDescription]
           ,[ReportCategoryId]
           )
     VALUES
           ('sample1',
			'#',
			'sample text',
			6			
           )	
INSERT INTO [ReportingCenterContent].[dbo].[MiscSet]
           ([Title]
           ,[Content]
           ,[TeamId]
           )
     VALUES
           ('misc'
           ,'misc'
           ,3
           )
INSERT INTO [ReportingCenterContent].[dbo].[IssueSet]
           ([Title]
           ,[Content]
           ,[TeamId]
           )
     VALUES
           ('issue'
           ,'issue'
           ,3
           )
INSERT INTO [ReportingCenterContent].[dbo].[NewsSet]
           ([Title]
           ,[Content]
           ,[TeamId]
           )
     VALUES
           ('news'
           ,'news'
           ,3
           )
		   	           
INSERT INTO [ReportingCenterContent].[dbo].[ReportCategorySet]
           ([ReportCategoryName]
           ,[TeamId])
     VALUES
           ('Category1'
           ,4)
INSERT INTO [ReportingCenterContent].[dbo].[ReportSet]
           ([ReportName]
           ,[ReportURL]
           ,[ReportDescription]
           ,[ReportCategoryId]
           )
     VALUES
           ('sample1',
			'#',
			'sample text',
			7			
           )
INSERT INTO [ReportingCenterContent].[dbo].[ReportCategorySet]
           ([ReportCategoryName]
           ,[TeamId])
     VALUES
           ('Category2'
           ,4)           
INSERT INTO [ReportingCenterContent].[dbo].[ReportSet]
           ([ReportName]
           ,[ReportURL]
           ,[ReportDescription]
           ,[ReportCategoryId]
           )
     VALUES
           ('sample1',
			'#',
			'sample text',
			8			
           )
INSERT INTO [ReportingCenterContent].[dbo].[MiscSet]
           ([Title]
           ,[Content]
           ,[TeamId]
           )
     VALUES
           ('misc'
           ,'misc'
           ,4
           )
INSERT INTO [ReportingCenterContent].[dbo].[IssueSet]
           ([Title]
           ,[Content]
           ,[TeamId]
           )
     VALUES
           ('issue'
           ,'issue'
           ,4
           )
INSERT INTO [ReportingCenterContent].[dbo].[NewsSet]
           ([Title]
           ,[Content]
           ,[TeamId]
           )
     VALUES
           ('news'
           ,'news'
           ,4
           )
INSERT INTO [ReportingCenterContent].[dbo].[ReportCategorySet]
           ([ReportCategoryName]
           ,[TeamId])
     VALUES
           ('Category1'
           ,5)                                            
INSERT INTO [ReportingCenterContent].[dbo].[ReportSet]
           ([ReportName]
           ,[ReportURL]
           ,[ReportDescription]
           ,[ReportCategoryId]
           )
     VALUES
           ('sample1',
			'#',
			'sample text',
			9			
           )
INSERT INTO [ReportingCenterContent].[dbo].[ReportCategorySet]
           ([ReportCategoryName]
           ,[TeamId])
     VALUES
           ('Category2'
           ,5)           
INSERT INTO [ReportingCenterContent].[dbo].[ReportSet]
           ([ReportName]
           ,[ReportURL]
           ,[ReportDescription]
           ,[ReportCategoryId]
           )
     VALUES
           ('sample1',
			'#',
			'sample text',
			10			
           )
INSERT INTO [ReportingCenterContent].[dbo].[MiscSet]
           ([Title]
           ,[Content]
           ,[TeamId]
           )
     VALUES
           ('misc'
           ,'misc'
           ,5
           )
INSERT INTO [ReportingCenterContent].[dbo].[IssueSet]
           ([Title]
           ,[Content]
           ,[TeamId]
           )
     VALUES
           ('issue'
           ,'issue'
           ,5
           )
INSERT INTO [ReportingCenterContent].[dbo].[NewsSet]
           ([Title]
           ,[Content]
           ,[TeamId]
           )
     VALUES
           ('news'
           ,'news'
           ,5
           )
GO



